package cj.hrm.dao;


import cj.hrm.entity.JobType;
import org.apache.ibatis.annotations.Select;

import java.util.List;

import static cj.hrm.util.common.HrmConstants.JOBTYPETABLE;

;

public interface JobTypeDao {

	//查询
	@Select("select * from "+JOBTYPETABLE+" ")
	List<JobType> selectAllJobType();
	
	@Select("select * from "+JOBTYPETABLE+" where name like CONCAT('%',#{content},'%')")
	List<JobType> selectLikeAllJobType(String content);

	@Select("select * from "+JOBTYPETABLE+" where id = #{id}")
	JobType selectById(Integer id);
}
